USE [SIGESIB]
GO

BEGIN TRAN

CREATE LOGIN Admin WITH PASSWORD = 'Sigesib2011'
CREATE USER Admin FOR LOGIN Admin;
GO 

exec sp_addrolemember db_datareader, Admin 
go
exec sp_addrolemember db_datawriter , Admin 
go
exec sp_addrolemember db_backupoperator , Admin 
go
GRANT EXECUTE TO Admin
go

SET IDENTITY_INSERT [dbo].[Usuarios] ON
INSERT [dbo].[Usuarios] ([Id], [Nome], [Login], [Senha], [Email], [IdPermissao], [Admin]) VALUES (1, N'Administrador', N'admin', N'Sigesib2011', N'', 127, 1)
SET IDENTITY_INSERT [dbo].[Usuarios] OFF

COMMIT TRAN